{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Explanation","Data","Model","Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":121,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Explanation","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Product Mix Application"]

{"sheet":"Data","index":1,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Data for Woodworks"]
[]
["Data on products: unit price, resources required per unit, minimum and maximum units",null,null,null,null,null,null,null,null,null,null,null,"Data on resources"]
["Product code","Description","UnitPrice","UnitCost","MinUnits","MaxUnits","SrLaborHrs","JrLaborHrs","MachineHrs","OakFt","CherryFt",null,"Resource","UnitCost","Availability"]
[1243,"Oak end table",190,{"$f":"MMULT(G5:K5,$N$5:$N$9)","v":129.6},20,40,0.5,1.3,0.4,2.8,0,null,"SrLaborHrs",20,263]
[2243,"Cherry end table",203,146.4,null,30,0.7,1.2,0.4,0,2.8,null,"JrLaborHrs",12,450]
[1456,"Oak rocking chair",371,276.8,5,20,2.1,2.9,1.2,5.2,0,null,"MachineHrs",15,225]
[2456,"Cherry rocking chair",407,308.39999999999998,5,15,2.5,2.7,1.2,0,5.2,null,"OakFt",35,488]
[1372,"Oak coffee table",238,167.4,10,30,1.3,1.7,0.6,3.2,0,null,"CherryFt",40,638]
[2372,"Cherry coffee table",259,185,null,10,1.5,1.5,0.6,0,3.2]
[1531,"Oak dining table",837,647.9,null,null,1.9,3.2,1.7,15.6,0]
[2531,"Cherry dining table",964,723.6,null,10,2.1,2.8,1.6,0,15.6]
[1635,"Oak desk",1084,840.6,5,null,4.3,5.8,3.2,18.2,0]
[2635,"Cherry desk",1214,937.7,5,null,4.5,5.6,3.5,0,18.2]
[1367,"Oak bookshelves",401,314.5,15,30,1.8,2.5,2.1,6.2,0]
[2367,"Cherry bookshelves",455,349,null,40,1.9,2.5,2.2000000000000002,0,6.2]

{"sheet":"Model","index":2,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Model formulation"]
[]
["Product mix"]
["Product code",2243,2456,1372,1531,2531]
["Min",0,5,10,0,0]
[null,"<=","<=","<=","<=","<="]
["Produced",30,15,30,25,10]
[null,"<=","<=","<=","<=","<="]
["Max",30,15,30,31,10]
[]
["UnitPrice",203,407,238,837,964]
["UnitCost",146.4,308.39999999999998,167.4,647.9,723.6]
["UnitProfit",{"$f":"B11-B12","v":56.599999999999994},{"$f":"C11-C12","v":98.600000000000023},{"$f":"D11-D12","v":70.599999999999994},{"$f":"E11-E12","v":189.10000000000002},{"$f":"F11-F12","v":240.39999999999998}]
[]
["Resource usage",null,null,null,null,"Monetary summary",null,null,"Resources used per unit of products"]
["Resource","Used",null,"Available",null,"Total revenue",{"$f":"SUMPRODUCT(Produced,UnitRev)","v":49900},null,"Resource/Product code",2243,2456,1372,1531,2531]
["SrLaborHrs",{"$f":"SUMPRODUCT(Produced,$J$17:$N$17)","v":166},"<=",263,null,"Total cost",{"$f":"SUMPRODUCT(Produced,UnitCost)","v":37473.5},null,"SrLaborHrs",0.7,2.5,1.3,1.9,2.1]
["JrLaborHrs",{"$f":"SUMPRODUCT(Produced,$J$18:$N$18)","v":235.5},"<=",450,null,"Total profit",{"$f":"SUMPRODUCT(Produced,UnitProfit)","v":12426.5},null,"JrLaborHrs",1.2,2.7,1.7,3.2,2.8]
["MachineHrs",{"$f":"SUMPRODUCT(Produced,$J$19:$N$19)","v":106.5},"<=",225,null,null,null,null,"MachineHrs",0.4,1.2,0.6,1.7,1.6]
["OakFt",{"$f":"SUMPRODUCT(Produced,$J$20:$N$20)","v":486},"<=",488,null,null,null,null,"OakFt",0,0,3.2,15.6,0]
["CherryFt",{"$f":"SUMPRODUCT(Produced,$J$21:$N$21)","v":318},"<=",638,null,null,null,null,"CherryFt",2.8,5.2,0,0,15.6]

{"sheet":"Report","index":3,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Optimal product mix"]
[]
["Monetary summary"]
["Total revenue",49900]
["Total cost",37473.5]
["Total profit",12426.5]
[]
["Product data",null,null,null,null,null,null,"Resource data"]
["Product code","Description","Units produced","Revenue","Cost","Profit",null,"Resource","Used","Available","Left over"]
[2243,"Cherry end table",30,6090,4392,1698,null,"SrLaborHrs",166,263,{"$f":"J10-I10","v":97}]
[2456,"Cherry rocking chair",15,6105,4626,1479,null,"JrLaborHrs",235.5,450,{"$f":"J11-I11","v":214.5}]
[1372,"Oak coffee table",30,7140,5022,2118,null,"MachineHrs",106.5,225,{"$f":"J12-I12","v":118.5}]
[1531,"Oak dining table",25,20925,16197.5,4727.5,null,"OakFt",486,488,{"$f":"J13-I13","v":2}]
[2531,"Cherry dining table",10,9640,7236,2404,null,"CherryFt",318,638,{"$f":"J14-I14","v":320}]